/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_party_contact_info.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PARTY_CONTACT_INFO
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_party_contact_info.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h" 


CTable_PPM_PARTY_CONTACT_INFO::CTable_PPM_PARTY_CONTACT_INFO( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PARTY_CONTACT_INFO" );
  prepareTable();
  prepareQuery();
 
  CONTACT_ID.setField( "CONTACT_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( CONTACT_ID );
  makeKeyItem( CONTACT_ID ); 
  CONTACT_NAME.setField( "CONTACT_NAME", DATA_CHAR, 32, 0 );
  makeTableItem( CONTACT_NAME );
  CONTACT_GENDER.setField( "CONTACT_GENDER", DATA_CHAR, 1, 0 );
  makeTableItem( CONTACT_GENDER );
  CONTACT_ADDRESS.setField( "CONTACT_ADDRESS", DATA_CHAR, 256, 0 );
  makeTableItem( CONTACT_ADDRESS );
  CONTACT_EMPLOYER.setField( "CONTACT_EMPLOYER", DATA_CHAR, 256, 0 );
  makeTableItem( CONTACT_EMPLOYER );
  HOME_PHONE.setField( "HOME_PHONE", DATA_CHAR, 30, 0 );
  makeTableItem( HOME_PHONE );
  OFFICE_PHONE.setField( "OFFICE_PHONE", DATA_CHAR, 32, 0 );
  makeTableItem( OFFICE_PHONE );
  MOBILE_PHONE.setField( "MOBILE_PHONE", DATA_CHAR, 32, 0 );
  makeTableItem( MOBILE_PHONE );
  CONTACT_DESC.setField( "CONTACT_DESC", DATA_CHAR, 256, 0 );
  makeTableItem( CONTACT_DESC );
  E_MAIL.setField( "E_MAIL", DATA_CHAR, 30, 0 );
  makeTableItem( E_MAIL );
  POSTCODE.setField( "POSTCODE", DATA_CHAR, 6, 0 );
  makeTableItem( POSTCODE );
  POST_ADDRESS.setField( "POST_ADDRESS", DATA_CHAR, 256, 0 );
  makeTableItem( POST_ADDRESS );
  FAX.setField( "FAX", DATA_CHAR, 30, 0 );
  makeTableItem( FAX );
  STATE.setField( "STATE", DATA_CHAR, 3, 0 );
  makeTableItem( STATE );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
}


CTable_PPM_PARTY_CONTACT_INFO::CTable_PPM_PARTY_CONTACT_INFO( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PARTY_CONTACT_INFO" );
  prepareTable();
  prepareQuery();
 
  CONTACT_ID.setField( "CONTACT_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( CONTACT_ID );
  makeKeyItem( CONTACT_ID ); 
  CONTACT_NAME.setField( "CONTACT_NAME", DATA_CHAR, 32, 0 );
  makeTableItem( CONTACT_NAME );
  CONTACT_GENDER.setField( "CONTACT_GENDER", DATA_CHAR, 1, 0 );
  makeTableItem( CONTACT_GENDER );
  CONTACT_ADDRESS.setField( "CONTACT_ADDRESS", DATA_CHAR, 256, 0 );
  makeTableItem( CONTACT_ADDRESS );
  CONTACT_EMPLOYER.setField( "CONTACT_EMPLOYER", DATA_CHAR, 256, 0 );
  makeTableItem( CONTACT_EMPLOYER );
  HOME_PHONE.setField( "HOME_PHONE", DATA_CHAR, 30, 0 );
  makeTableItem( HOME_PHONE );
  OFFICE_PHONE.setField( "OFFICE_PHONE", DATA_CHAR, 32, 0 );
  makeTableItem( OFFICE_PHONE );
  MOBILE_PHONE.setField( "MOBILE_PHONE", DATA_CHAR, 32, 0 );
  makeTableItem( MOBILE_PHONE );
  CONTACT_DESC.setField( "CONTACT_DESC", DATA_CHAR, 256, 0 );
  makeTableItem( CONTACT_DESC );
  E_MAIL.setField( "E_MAIL", DATA_CHAR, 30, 0 );
  makeTableItem( E_MAIL );
  POSTCODE.setField( "POSTCODE", DATA_CHAR, 6, 0 );
  makeTableItem( POSTCODE );
  POST_ADDRESS.setField( "POST_ADDRESS", DATA_CHAR, 256, 0 );
  makeTableItem( POST_ADDRESS );
  FAX.setField( "FAX", DATA_CHAR, 30, 0 );
  makeTableItem( FAX );
  STATE.setField( "STATE", DATA_CHAR, 3, 0 );
  makeTableItem( STATE );
  STATE_DATE.setField( "STATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( STATE_DATE );
  CREATE_DATE.setField( "CREATE_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( CREATE_DATE );
}

CTable_PPM_PARTY_CONTACT_INFO::~CTable_PPM_PARTY_CONTACT_INFO( )
{
    close();
}

